How to create Login and Registration Page using PHP and Xampp

Firstly, You must have a knowledge on MySQL.

Create a database table.

CREATE TABLE IF NOT EXISTS  `users` ( `id` int ( 11 )  NOT NULL  AUTO_INCREMENT , `username`  varchar ( 255 )   NOT NULL , `password`  varchar ( 255 )   NOT NULL , `first_name`  varchar ( 255 )   NOT NULL , `last_name`  varchar ( 255 )   NOT NULL , `email`  varchar ( 255 )  NOT  NULL ,   PRIMARY KEY  ( `id` ),    UNIQUE KEY  `username` ( `username` ),   UNIQUE KEY  `email` ( `email` ) )  ENGINE = InnoDB  DEFAULT  CHARSET = latin1  AUTO_INCREMENT = 1 ;

if you are using mysql use myadmin to create these fields so that it would be easier for you.
Now I have defined the constants that are required to connect to the database Create a file name it dbConstants. or name it whatever you want.

Now the code for login page create a file called <login.

<html><head><title> Login Form | 9jaclassic.ga</title> </head><body> <?  if (!isset(_POST["submit"])){?>  <form action="<?=_SERVER["PHP_SELF"]?>"  method="post">         Username:  <input type = "text" name = "username" /><br />         Password:  <input type = "password" name = "password" /><br /> <input type = "submit" name = "submit" value = "Login" /> </form><? } else {     require_once("db_const.");     mysqli  = new  mysqli (DB_HOST, DB_USER , DB_PASS, DB_NAME); # check connection if ( mysqli -> connect_errno ) {         echo  "<p>MySQL error  no {mysqli->connect_errno} :  {mysqli->connect_error}</p>" ; exit (); }     username  =  _POST [ "username" ];     password  =  _POST [ "password" ];     sql  = "SELECT * from users WHERE  username LIKE "{username}"  AND password LIKE  "{password}" LIMIT 1" ;     result  =  mysqli -> query ( sql ); if (! result -> num_rows  == 1 ) {         echo  "<p>Invalid  username/password  combination</p>" ; } else {         echo  "<p>Logged in  successfully</p>" ; // do stuffs } } ?> </body> </html>

and finally the code for registration create a file called register.

<html><head><title> Registration</title> </head> <body><? require_once("db_const."); if (! isset ( _POST [ "submit" ])) { ?>      <form action="<?=_SERVER["PHP_SELF"]?>"  method="post">         Username:  <input type = "text" name = "username" /><br />         Password:  <input type = "password" name = "password" /><br />         First name:  <input type = "text" name = "first_name" /><br />         Last name:  <input type = "text" name = "last_name" /><br />         Email:  <input type = "type" name = "email" /><br /> <input type = "submit" name = "submit" value = "Register" /> </form> <?  } else { ## connect mysql server     mysqli  = new  mysqli ( DB_HOST ,   DB_USER ,  DB_PASS ,  DB_NAME ); # check connection if ( mysqli -> connect_errno ) {         echo  "<p>MySQL error  no {mysqli->connect_errno} :  {mysqli->connect_error}</p>" ; exit (); } ## query database # prepare data for insertion     username    =  _POST [ "username" ];     password    =  _POST [ "password" ];     first_name  =  _POST [ "first_name" ];     last_name   =  _POST [ "last_name" ];     email       =  _POST [ "email" ]; # check if username and email exist else insert     exists  = 0 ;     result  =  mysqli -> query ( "SELECT username from users WHERE username =  "{username}" LIMIT 1" ); if ( result -> num_rows  == 1 ) {         exists  = 1 ;         result  =  mysqli -> query ( "SELECT email from  users WHERE email = "{email}"  LIMIT 1" ); if ( result -> num_rows  == 1 )  exists  = 2 ; } else {         result  =  mysqli -> query ( "SELECT email from  users WHERE email = "{email}"  LIMIT 1" ); if ( result -> num_rows  == 1 )  exists  = 3 ; } if ( exists  == 1 )  echo  "<p>Username  already exists!</p>" ; else if ( exists  == 2 )  echo  "<p>Username and  Email already exists!</p>" ; else if ( exists  == 3 )  echo  "<p>Email already  exists!</p>" ; else { # insert data into mysql  database         sql  = "INSERT  INTO `users` (`id`,  `username`, `password`,  `first_name`, `last_name`,  `email`)                  VALUES (NULL,  "{username}", "{password}",  "{first_name}", "{last_name}",  "{email}")" ; if ( mysqli -> query ( sql )) { //echo "New Record has id ".mysqli->insert_id;              echo  "<p>Registred  successfully!</p>" ; } else {             echo  "<p>MySQL  error no {mysqli->errno} :  {mysqli->error}</p>" ; exit (); } } } ?> </body> </html>

This is a simple login and registration process I hope it helps you although things I have given here may not be best practises

Show Some Love By Sharing This Page On:
FacebookTwitter
GoogleplusPinterest
LinkedinWhatsApp
WordPressTumblr
Digg-DiggStumbleUpon
RedditSMSBlogger

Home » php » How to create Login and Registration Page using PHP and Xampp » How to create Login and Registration Page using PHP and Xampp

How to create Login and Registration Page using PHP and Xampp

RELATED ARTICLES